package com.zjff.myshop.mapper;

import com.zjff.myshop.entity.Order;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

public interface OrderMapper {
    int insert(Order order);

    int deleteByPrimaryKey(Integer id);

    int update(Order order);

    Order selectByPrimaryKey(Integer id);

    List<Order> selectPage(Map map); //map有userId、status、orderBy  默认order by id

    List<Map<String, Object>> selectOrderSumByCategory(String dtBgn, String dtEnd);

    List<Map<String, Object>> selectOrderSumByMonth(Integer year);

}